1z0-338: Oracle Exadata Database Machine and Cloud Service 2017 Implementation Essentials

The Exadata architecture is divided into two specific tiers: the database tier and the storage tier.

What protocol do these tiers use to communicate with each other?

iDB – Intelligent Database Protocol
InfiniBand protocol
Ethernet protocol
Secure Shell protocol
Fibre Channel protocol

Correct answer: A

Explanation:

Reference: https://docs.oracle.com/cd/E50790_01/doc/doc.121/e50471/concepts.htm#SAGUG20333

Your customer needs to ensure that their data is available on the Exadata machine during patches. The customer wants to be able to patch one server at a time but still be protected against single-node server failure.

What ASM redundancy level should they use?

High
Normal
External
Extreme
Standard

Correct answer: B

Explanation:

Reference http://www.oracle.com/technetwork/database/exadata/maa-exadata-asm-cloud-3656632.pdf (page 7)

In which three ways can customers access the ILOM interface to manage the Exadata database and storage server hardware components? (Choose three.)

ILOM CLI interface through the management network
ILOM Web interface through the management network
remote KVM session to the ILOM
from the database server operating system tool "ilomcli"
from the storage server operating system tool "ilomcli"

Correct answer: BCE

Your customer is implementing a storage consolidation strategy on their existing Exadata.

Which step represents the Oracle recommended action that the customer should take in their approach?

Do not use IORM because it will interfere with the shared database functionality on Exadata.
Use ASM to create separate diskgroups for each database instance that is running on Exadata.
Use IORM to distribute disk bandwidth among the databases.
Set up Oracle Grid Infrastructure to use multiple clusters per hardware pool.
Set up a resource consumer group within each database instance and manage it individually.

Correct answer: C

Explanation:

Reference: http://www.oracle.com/technetwork/topics/cloud/whatsnew/mixedworkloadmgmtexadata-300345.pdf page 42

How does Advanced Compression differ from Hybrid Columnar Compression?

Advanced Compression is free to use on Exadata Database Machine, whereas Hybrid Columnar Compression must be purchased.
They are the same; Advanced Compression is called Hybrid Columnar Compression on Exadata Database Machine.
Hybrid Columnar Compression is good for tables with active updates and deletes, and provides deeper compression ratios.
Advanced Compression is good for tables with active updates and deletes, whereas Hybrid Columnar Compression is best applied to tables or partitions where data is fairly static.

Correct answer: D

The Exadata compute node, exadbs04, has been having issues for some time. The server had to be repaired and you just received a new server. Your LVM snapshot was corrupt and now the compute node must be re-imaged with an Oracle Support installation image.

Which three tasks must be performed in order to re-image the compute node? (Choose three.)

Create a CELLBOOT USB Flash Drive by using an external USB drive.
Mount the LVM backup image across the network and recover the system.
Remove exadbs04 from the RAC cluster and all associated Oracle Homes from the central inventory.
Reboot the new server by using a bootable recovery image from the external USB drive.
Reconfigure all site-specific settings (host name, IP addresses, NTP server, and so on).

Correct answer: CDE

Your government customer has purchased a full rack of Exadata. The customer has two departments that would like to share the Exadata Database Machine but the concern is that department A will be able to see data from department B.

Which architecture would you suggest to solve this deployment issue?

Split the configuration by using Oracle Nimbula's cloud software so that four database servers and seven cells can be used by department A and the rest can be used by department B.
Split the configuration and use ASM-Scoped Security so that four database servers and seven cells can be used by department A and the rest can be used by department B.
Set up instance caging to ensure that department A has access only to four database servers and seven cells and department B has access to the rest.
Define the split by setting up database services that are specific to department A and department B.

Correct answer: D

There are many different ways to load data into database tables.

Which method does Oracle strongly recommend?

generic connectivity via ODBC or JDBC
database gateways to open systems and mainframes
Oracle GoldenGate
Oracle Data Pump
SQL*Loader import
data loading via external tables

Correct answer: F

Which options does not benefit from storage offload processing?

indexes that rely on B-Tree pointers
column filtering
joins and aggregation
table scans
incremental backups with block change tracking

Correct answer: A

Explanation:

Reference: https://www.pythian.com/blog/exadata-join-offloading-in-action/

Your customer would like to configure monitoring capabilities alongside ASR on the stand-alone server that was set aside to run ASR Manager.

What configuration would you set up for the customer?

Enterprise Manager, SQL Developer Server, and ASR Manager on the stand-alone server because ASR needs SQL Developer to gain SQL access to the database server
ASR Manager inside the firewall to ensure that root access to Exadata Database Machine is not compromised
ASR Manager with SNMP traps configured to listen for specific alerts triggered by Exadata Database Machine
Enterprise Manager (Ops Center) and ASR Manager on the stand-alone server because ASR is not a monitoring tool

Correct answer: D

Vendor:	Oracle
Exam Code:	1z0-338
Exam Name:	Oracle Exadata Database Machine and Cloud Service 2017 Implementation Essentials
Date:	Aug 05, 2018
File Size:	143 KB

Download Oracle Exadata Database Machine and Cloud Service 2017 Implementation Essentials.1z0-338.PracticeTest.2018-08-05.46q.vcex

How to open VCEX files?

Demo Questions

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

ProfExam at a 20% markdown